search

siara-cc / esp32-idf-sqlite3

Sqlite library for esp-idf (esp32) framework
Apache License 2.0
139 stars 49 forks source link

Support for Esp32-S3 #12

Open ArturG16 opened 2 years ago

ArturG16 commented 2 years ago

Hi, I've the new module ESP32-S3.I use this component in my project with ESP32, but I want to update it for the new target. I changed the Cmakelist with this argument -> set(CMAKE_C_COMPILER "xtensa-esp32s3-elf-gcc").

And worked, but I've got some warnings... [1029/1312] Building C object esp-idf/..._idf_esp32-idf-sqlite3.dir/esp32.c.obj /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:124:1: warning: missing initializer for field 'xCurrentTimeInt64' of 'sqlite3_vfs' {aka 'struct sqlite3_vfs'} [-Wmissing-field-initializers] }; ^ In file included from /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:16: /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/include/sqlite3.h:1352:9: note: 'xCurrentTimeInt64' declared here int (xCurrentTimeInt64)(sqlite3_vfs, sqlite3_int64); ^~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:140:1: warning: missing initializer for field 'xShmMap' of 'sqlite3_io_methods' {aka 'const struct sqlite3_io_methods'} [-Wmissing-field-initializers] }; ^ In file included from /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:16: /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/include/sqlite3.h:789:9: note: 'xShmMap' declared here int (xShmMap)(sqlite3_file*, int iPg, int pgsz, int, void volatile); ^~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:156:1: warning: missing initializer for field 'xShmMap' of 'sqlite3_io_methods' {aka 'const struct sqlite3_io_methods'} [-Wmissing-field-initializers] }; ^ In file included from /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:16: /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/include/sqlite3.h:789:9: note: 'xShmMap' declared here int (xShmMap)(sqlite3_file, int iPg, int pgsz, int, void volatile); ^~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32mem_Sync': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:338:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_Open': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:393:16: warning: ordered comparison of pointer with integer zero [-Wextra] if ( p->fd <= 0 ) { ^~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:354:6: warning: unused variable 'rc' [-Wunused-variable] int rc; ^~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_Read': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:430:20: warning: comparison of unsigned expression >= 0 is always true [-Wtype-limits] } else if ( nRead >= 0 ) { ^~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_Truncate': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:465:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_Lock': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:544:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_Unlock': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:552:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_CheckReservedLock': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:560:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_FileControl': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:570:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_SectorSize': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:578:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'esp32_DeviceCharacteristics': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:586:14: warning: unused variable 'file' [-Wunused-variable] esp32_file file = (esp32_file) id; ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'shox96_0_2d': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:669:27: warning: unused variable 'rc' [-Wunused-variable] unsigned int nIn, nOut, rc; ^~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c: In function 'sqlite3_os_init': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/esp32.c:706:26: warning: cast between incompatible function types from 'int ()(sqlite3 , const char *, const struct sqlite3_api_routines )' {aka 'int ()(struct sqlite3 , const char *, const struct sqlite3_api_routines )'} to 'void ()()' [-Wcast-function-type] sqlite3_auto_extension((void ()())registerShox96_0_2); ^ [1031/1312] Building C object esp-idf/...esp32-idf-sqlite3.dir/shox96_0_2.c.obj /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/shox96_0_2.c: In function 'shox96_0_2_compress': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/shox96_0_2.c:273:39: warning: array subscript has type 'char' [-Wchar-subscripts] ol = append_bits(out, ol, c_95[c_in], l_95[c_in], state); ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/shox96_0_2.c:273:51: warning: array subscript has type 'char' [-Wchar-subscripts] ol = append_bits(out, ol, c_95[c_in], l_95[c_in], state); ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/shox96_0_2.c: In function 'shox96_0_2_decompress': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/shox96_0_2.c:445:11: warning: 'c' may be used uninitialized in this function [-Wmaybe-uninitialized] c -= 32; ^~~ [1305/1312] Building C object esp-idf/...df_esp32-idf-sqlite3.dir/sqlite3.c.obj /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'strftimeFunc': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:21749:52: note: in expansion of macro 'SQLITE_DYNAMIC' z==zBuf ? SQLITE_TRANSIENT : SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3ErrorWithMsg': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:30000:54: note: in expansion of macro 'SQLITE_DYNAMIC' sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'balance_nonroot': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:70620:11: warning: unused variable 'key' [-Wunused-variable] u32 key = get4byte(&apNew[i]->aData[8]); ^~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'balance': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:70741:6: warning: unused variable 'aBalanceQuickSpace' [-Wunused-variable] u8 aBalanceQuickSpace[13]; ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3VdbeMemSetStr': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:74734:19: note: in expansion of macro 'SQLITE_DYNAMIC' }else if( xDel==SQLITE_DYNAMIC ){ ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'valueFromExpr': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:75139:55: note: in expansion of macro 'SQLITE_DYNAMIC' sqlite3ValueSetStr(pVal, -1, zVal, SQLITE_UTF8, SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3VdbeHalt': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:20225:34: warning: statement with no effect [-Wunused-value]

define sqlite3VdbeCheckFk(p,i) 0

                              ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:78355:7: note: in expansion of macro 'sqlite3VdbeCheckFk' sqlite3VdbeCheckFk(p, 0); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3AlterFinishAddColumn': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:101398:10: warning: variable 'pTab' set but not used [-Wunused-but-set-variable] Table pTab; / Table being altered / ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'printfFunc': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void *)' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:111863:25: note: in expansion of macro 'SQLITE_DYNAMIC' SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3Insert': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116145:1: warning: label 'insert_end' defined but not used [-Wunused-label] insert_end: ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'generateColumnNames': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:125012:58: note: in expansion of macro 'SQLITE_DYNAMIC' sqlite3VdbeSetColName(v, i, COLNAME_NAME, zName, SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:13957:27: warning: cast between incompatible function types from 'int ()(void )' to 'void ()(void )' [-Wcast-function-type]

define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)

                       ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:125019:52: note: in expansion of macro 'SQLITE_DYNAMIC' sqlite3VdbeSetColName(v, i, COLNAME_NAME, z, SQLITE_DYNAMIC); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'flattenSubquery': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:1456:29: warning: statement with no effect [-Wunused-value]

define SQLITE_OK 0 / Successful result /

                         ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:18824:41: note: in expansion of macro 'SQLITE_OK'

define sqlite3AuthCheck(a,b,c,d,e) SQLITE_OK

                                     ^~~~~~~~~

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:126949:17: note: in expansion of macro 'sqlite3AuthCheck' TESTONLY(i =) sqlite3AuthCheck(pParse, SQLITE_SELECT, 0, 0, 0); ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3Select': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:1456:29: warning: statement with no effect [-Wunused-value]

define SQLITE_OK 0 / Successful result /

                         ^

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:18824:41: note: in expansion of macro 'SQLITE_OK'

define sqlite3AuthCheck(a,b,c,d,e) SQLITE_OK

                                     ^~~~~~~~~

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:128924:7: note: in expansion of macro 'sqlite3AuthCheck' sqlite3AuthCheck(pParse, SQLITE_READ, pItem->zName, "", pItem->zDatabase); ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3DropTriggerPtr': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:130532:12: warning: variable 'pTable' set but not used [-Wunused-but-set-variable] Table pTable; ^~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3VtabBeginParse': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:133021:7: warning: variable 'iDb' set but not used [-Wunused-but-set-variable] int iDb; / The database the table is being created in / ^~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'whereLoopAddBtree': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:141187:10: warning: variable 'rLogSize' set but not used [-Wunused-but-set-variable] LogEst rLogSize; / Logarithm of the number of rows in the table / ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3InvokeBusyHandler': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:153341:12: warning: cast between incompatible function types from 'int ()(void , int)' to 'int ()(void , int, sqlite3_file )' {aka 'int ()(void , int, struct sqlite3_file )'} [-Wcast-function-type] xTra = (int()(void,int,sqlite3_file))p->xBusyHandler; ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3_busy_timeout': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:153419:30: warning: cast between incompatible function types from 'int ()(void , int, sqlite3_file )' {aka 'int ()(void , int, struct sqlite3_file )'} to 'int ()(void , int)' [-Wcast-function-type] sqlite3_busy_handler(db, (int()(void,int))sqliteDefaultBusyCallback, ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: At top level: /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:14199:20: warning: 'sqlite3BtreeIncrVacuum' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE int sqlite3BtreeIncrVacuum(Btree ); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:14416:22: warning: 'sqlite3BtreeIntegrityCheck' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE char sqlite3BtreeIntegrityCheck(Btree, int aRoot, int nRoot, int, int); ^~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:15258:20: warning: 'sqlite3PagerMovepage' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE int sqlite3PagerMovepage(Pager,DbPage,Pgno,int); ^~~~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:18893:22: warning: 'sqlite3HexToBlob' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE void sqlite3HexToBlob(sqlite3, const char z, int n); ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:18957:21: warning: 'sqlite3RootPageMoved' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE void sqlite3RootPageMoved(sqlite3, int, int, int); ^~~~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:20134:20: warning: 'sqlite3VdbeList' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE int sqlite3VdbeList(Vdbe); ^~~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:20173:28: warning: 'sqlite3OpcodeName' declared 'static' but never defined [-Wunused-function] SQLITE_PRIVATE const char *sqlite3OpcodeName(int); ^~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:115455:12: warning: 'xferOptimization' declared 'static' but never defined [-Wunused-function] static int xferOptimization( ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3_db_status': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:20572:10: warning: this statement may fall through [-Wimplicit-fallthrough=] op = SQLITE_DBSTATUS_CACHE_WRITE+1;

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:20574:5: note: here
     case SQLITE_DBSTATUS_CACHE_HIT:
     ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3_str_vappendf':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:27280:19: warning: this statement may fall through [-Wimplicit-fallthrough=]
         flag_long = sizeof(char*)==sizeof(i64) ? 2 :
         ~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                      sizeof(char*)==sizeof(long int) ? 1 : 0;

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:27283:7: note: here case etORDINAL: ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:27285:19: warning: this statement may fall through [-Wimplicit-fallthrough=] cThousand = 0;

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:27287:7: note: here
       case etDECIMAL:
       ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3GetToken':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:151072:9: warning: this statement may fall through [-Wimplicit-fallthrough=]
       if( !sqlite3Isdigit(z[1]) )
         ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:151081:5: note: here
     case CC_DIGIT: {
     ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3ExprCodeTarget':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:99150:25: warning: this statement may fall through [-Wimplicit-fallthrough=]
     case TK_AGG_COLUMN: {
                         ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:99163:5: note: here
     case TK_COLUMN: {
     ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'resolveP2Values':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:76200:13: warning: this statement may fall through [-Wimplicit-fallthrough=]
           if( pOp->p2!=0 ) p->readOnly = 0;
             ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:76203:9: note: here
         case OP_AutoCommit:
         ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:76241:26: warning: this statement may fall through [-Wimplicit-fallthrough=]
         case OP_VFilter: {
                          ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:76250:9: note: here
         default: {
         ^~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'resolveExprStep':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:95012:20: warning: this statement may fall through [-Wimplicit-fallthrough=]
     case TK_ISNOT: {
                    ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:95028:5: note: here
     case TK_BETWEEN:
     ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'impliesNotNullRow':
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:100692:8: warning: this statement may fall through [-Wimplicit-fallthrough=]
       if( (pExpr->pLeft->op==TK_COLUMN && IsVirtual(pExpr->pLeft->pTab))
    || (pExpr->pRight->op==TK_COLUMN && IsVirtual(pExpr->pRight->pTab))
    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:100696:5: note: here default: ^~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3GenerateConstraintChecks': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116561:17: warning: this statement may fall through [-Wimplicit-fallthrough=] onError = OE_Abort; ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116564:7: note: here case OE_Rollback: ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116624:9: warning: this statement may fall through [-Wimplicit-fallthrough=] sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, 0, iDataCur); ^~~~~~~~~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116628:7: note: here case OE_Ignore: { ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116833:9: warning: this statement may fall through [-Wimplicit-fallthrough=] sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, pIdx, iIdxCur+ix); ^~~~~~~~~~~~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116837:7: note: here case OE_Ignore: { ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c: In function 'sqlite3VdbeExec': /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:83605:5: warning: this statement may fall through [-Wimplicit-fallthrough=] if( (pIn3->flags & MEM_Null)==0 ) break; ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:83639:1: note: here case OP_Halt: { ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:83772:5: warning: this statement may fall through [-Wimplicit-fallthrough=] if( pOp->p1>db->aLimit[SQLITE_LIMIT_LENGTH] ){ ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:83791:1: note: here case OP_String: { / out2 / ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:86833:19: warning: this statement may fall through [-Wimplicit-fallthrough=] case OP_IfNoHope: { / jump, in3 / ^ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:86841:1: note: here case OP_NoConflict: / jump, in3 / ^~~~ /home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:87769:38: warning: this statement may fall through [-Wimplicit-fallthrough=] p->aCounter[SQLITE_STMTSTATUS_SORT]++;


/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:87788:1: note: here
 case OP_Rewind: {        /* jump */
 ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:89069:15: warning: this statement may fall through [-Wimplicit-fallthrough=]
   pOp->opcode = OP_AggStep1;
               ^
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:89072:1: note: here
 case OP_AggStep1: {
 ^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:89932:15: warning: this statement may fall through [-Wimplicit-fallthrough=]
   pOp->opcode += 2;
   ~~~~~~~~~~~~^~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:89935:1: note: here
 case OP_PureFunc:              /* group */
 ^~~~
At top level:
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:127533:15: warning: 'isSimpleCount' defined but not used [-Wunused-function]
 static Table *isSimpleCount(Select *p, AggInfo *pAggInfo){
               ^~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:126012:12: warning: 'generateOutputSubroutine' defined but not used [-Wunused-function]
 static int generateOutputSubroutine(
            ^~~~~~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:120022:12: warning: 'integrityCheckResultRow' defined but not used [-Wunused-function]
 static int integrityCheckResultRow(Vdbe *v){
            ^~~~~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:116222:12: warning: 'checkConstraintUnchanged' defined but not used [-Wunused-function]
 static int checkConstraintUnchanged(Expr *pExpr, int *aiChng, int chngRowid){
            ^~~~~~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:75997:21: warning: 'sqlite3VdbeReusable' defined but not used [-Wunused-function]
 SQLITE_PRIVATE void sqlite3VdbeReusable(Vdbe *p){
                     ^~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:75790:21: warning: 'sqlite3VdbeMultiLoad' defined but not used [-Wunused-function]
 SQLITE_PRIVATE void sqlite3VdbeMultiLoad(Vdbe *p, int iDest, const char *zTypes, ...){
                     ^~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:72141:12: warning: 'btreeHeapPull' defined but not used [-Wunused-function]
 static int btreeHeapPull(u32 *aHeap, u32 *pOut){
            ^~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:72131:13: warning: 'btreeHeapInsert' defined but not used [-Wunused-function]
 static void btreeHeapInsert(u32 *aHeap, u32 x){
             ^~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:65591:20: warning: 'sqlite3BtreeGetAutoVacuum' defined but not used [-Wunused-function]
 SQLITE_PRIVATE int sqlite3BtreeGetAutoVacuum(Btree *p){
                    ^~~~~~~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:65567:20: warning: 'sqlite3BtreeSetAutoVacuum' defined but not used [-Wunused-function]
 SQLITE_PRIVATE int sqlite3BtreeSetAutoVacuum(Btree *p, int autoVacuum){
                    ^~~~~~~~~~~~~~~~~~~~~~~~~
/home/artur/esp/esp-idf/components/esp32-idf-sqlite3/sqlite3.c:63163:13: warning: 'invalidateAllOverflowCache' defined but not used [-Wunused-function]
 static void invalidateAllOverflowCache(BtShared *pBt){
             ^~~~~~~~~~~~~~~~~~~~~~~~~~
[1311/1312] Generating binary image from built executable
esptool.py v3.2-dev
Merged 2 ELF sections
Generated /home/artur/Projects/blufi/build/blufi_demo.bin
[1312/1312] cd /home/artur/Projects/bl...ur/Projects/blufi/build/blufi_demo.bin
blufi_demo.bin binary size 0xd6700 bytes. Smallest app partition is 0x177000 bytes. 0xa0900 bytes (43%) free.

Project build complete. To flash, run this command:

How can I solved That?
ArturG16 commented 2 years ago

To remove the warnings we must set the new cmake file like that: set(COMPONENT_ADD_INCLUDEDIRS "include")

idf_component_register(SRCS "sqlite3.c" "esp32.c" "shox96_0_2.c" INCLUDE_DIRS "include" PRIV_INCLUDE_DIRS "private_include" REQUIRES mbedtls PRIV_REQUIRES console spiffs) set_source_files_properties( sqlite3.c PROPERTIES COMPILE_FLAGS "-Wno-unused-function -Wno-unused-variable -Wno-unused-value -Wno-unused-label -Wno-missing-field-initializers -Wno-unused-but-set-variable -Wno-maybe-uninitialized -Wno-unused-parameter -Wno-implicit-fallthrough -Wno-cast-function-type" ) set_source_files_properties( esp32.c PROPERTIES COMPILE_FLAGS "-Wno-unused-function -Wno-unused-variable -Wno-unused-value -Wno-extra -Wno-type-limits -Wno-unused-label -Wno-missing-field-initializers -Wno-unused-but-set-variable -Wno-maybe-uninitialized -Wno-unused-parameter -Wno-implicit-fallthrough -Wno-cast-function-type" ) set_source_files_properties( shox96_0_2.c PROPERTIES COMPILE_FLAGS "-Wno-unused-function -Wno-unused-variable -Wno-char-subscripts -Wno-unused-value -Wno-unused-label -Wno-missing-field-initializers -Wno-unused-but-set-variable -Wno-maybe-uninitialized -Wno-unused-parameter -Wno-implicit-fallthrough -Wno-cast-function-type" )

target_compile_options(${COMPONENT_LIB} PRIVATE -std=gnu99 -g3 -fno-stack-protector -ffunction-sections -fdata-sections -fstrict-volatile-bitfields -mlongcalls -nostdlib -Wpointer-arith -Wno-error=unused-value -Wno-error=unused-label -Wno-error=unused-function -Wno-error=unused-but-set-variable -Wno-error=unused-variable -Wno-error=deprecated-declarations -Wno-error=char-subscripts -Wno-error=maybe-uninitialized -Wno-unused-parameter -Wno-sign-compare -Wno-old-style-declaration -MMD -c -DF_CPU=240000000L -DESP32 -DCORE_DEBUG_LEVEL=0 -DNDEBUG)

ArturG16 commented 2 years ago

And to support all boards we must change on esp32.c

if CONFIG_IDF_TARGET_ESP32

include "esp32/rom/ets_sys.h"

elif CONFIG_IDF_TARGET_ESP32S2

include "esp32s2/rom/ets_sys.h"

elif CONFIG_IDF_TARGET_ESP32S3

include "esp32s3/rom/ets_sys.h"

endif

siara-cc commented 2 years ago

Hi @ArturG16 Thank you for sharing the great findings with the newer esp boards. I will incorporate them in the repo during the weekend.