Comments (5)
If I remember correctly, it is officially supported (albeit deprecated)
https://www.sqlite.org/lang_keywords.html
from php-src.
Citing from https://www.sqlite.org/lang_keywords.html
If a keyword in double quotes (ex: "key" or "glob") is used in a context where it cannot be resolved to an identifier but where a string literal is allowed, then the token is understood to be a string literal instead of an identifier.
probably because of this paragraph.
As shown in the dbfiddle.uk and sqlite.org/fiddle/ repros, the "historical mode" is not always used.
Can this "historical mode" be disabled in current PHP releases thru some flag?
For master (if classified as a feature request), I would expect this "historical mode" to be disabled by default. Suppressing missing columns errors by assuming string literals is very dangerous and unwanted.
from php-src.
based on https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted it can be configured like:
sqlite3_db_config(db, SQLITE_DBCONFIG_DQS_DDL, 0, (void*)0);
sqlite3_db_config(db, SQLITE_DBCONFIG_DQS_DML, 0, (void*)0);
man: https://www.sqlite.org/c3ref/c_dbconfig_defensive.html
As of SQLite 3.41.0 (2023-02-21) SQLITE_DBCONFIG_DQS_DDL and SQLTIE_DBCONFIG_DQS_DML are disabled by default in the CLI.
this also explains why the SQLite/native repro does not suffer with this issue
from php-src.
If php accepts this proposed change, it is expected that it will probably break many user environments.
This is definitely a BC Break, and an RFC is required to prohibit it across the board.
Another option is to allow the user to select this, such as using pdo's setAttribute. I don't think an RFC is needed if the default value is the existing behavior.
from php-src.
IMHO, while SQLite supports this feature, php should also be able to take advantage of this. So instead of banning it outright, I think it would be better to have options.
from php-src.
Related Issues (20)
- PHP version 8.3.7 compiles and tests on the curl 7.76.1 extension and reports an error HOT 2
- Is there a development tutorial for expanding the library? HOT 2
- Using `--enable-fuzzer` with `--enable-zts` cause compilation to fail HOT 2
- pdo_pgsql: question marks seen as parameter placeholders in dollar-quoted string HOT 2
- Weird behaviour for DNS resolution HOT 1
- mysqli_fetch_assoc reports error from nested query HOT 1
- Implement ED25519 auth for mysqlnd HOT 3
- PHP 8.2.19: segfault at 7f377e872428 (sp 00007ffcd580fec0 error 4) HOT 32
- opcache.jit=off does not behave as documented
- Has PHP added support for generics, similar to Java's generics HOT 5
- Can't cross-compile with external libcrypt HOT 1
- ffi enum type (when enum has no name) make memory leak HOT 2
- Can the final PHP code be compiled into binary and run on the server, which is more secure on the server side and less likely to cause code intrusion? Currently, the traditional deployment method is through source code, which is easily exposed and tampered with. We deploy more security. Java like jar packages are not even more secure. HOT 1
- Member access within null pointer in extension spl
- PHP 8 Compile with GD Help needed HOT 1
- Indexing an array with a persistent string triggers an assertion failure during destruction HOT 4
- Seeing seg fault while using zend_disable_functions during shutdown HOT 1
- Preg unicode different results depending on if in character class or separate
- Test curl_basic_024 fails with curl 8.8.0 HOT 1
- PHP 8.1.28 curl_exec crash with no error on first request after second request is made (fast F5) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from php-src.